Question1: You want to specify a model and dimension members that are used every time you create WEB reports. Where do you set this values? (1)
Question2: Which model types are required to consolidate investments?
There are 3 correct answers to this question.
Response:
Question3: The parent company D owns 91% of company A, 51% of company B and 49% of company C.
which company can use the equity method? Please choose the correct answer.
Response:
Question4: How to reset the consolidation status? 1 BPC440
Question5: You are working in BPC Embedded.Data audit is enabled for a local provide.Whatfileds are added to the local provider database table? (3)
Question6: You want to use a data manager package to load data from an InfoProvider in BPC for NetWeaver. What is supported?
There are 2 correct answers to this question.
Response:
Question7: Which of the following tasks can you perfoam using a data manager package delivered by SAP?
Note: There are 3 correct answers to the question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question8: You use an account by entity report and want to drill download on parent accounts for one entity at a time, as in the attached screenshot.
How to you achieve this drilldownl behavior?
Please choose the correct answer.
Response:
Question9: You are working in a BPC Embedded system. What object can you maintain immediately after creating an environment? (1)
Question10: You are implementing a planning solution that uses BPC Embedded When you run a planning function, you notice that it is NOT optimized. How can you resolve this issue?
Note; There are 3 correct answers to this question
Question11: During testing you notice that account descriptions are missing. How do you resolve this issue?
Response:
Question12: What dimension and value does the Method Based Multiplier determine?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question13: Which of the following steps are mandatory if you want to perform a transport from the development system to the production system(administration)? (2)
Question14: You are the administrator on a BPC 11.0 for SAP BW/4HANA system. You need to optimize an Advanced
DataStore Object by activating the data. What happens when you do this? Note: There are 2 correct answers to
this question.
Question15: Process for importing flat file data. Select from the following
choose the correct answer
Response:
Question16: What dimension and value does the Method Based Multiplier determine?
Question17: You want to use a data manager package to load data from an InfoProvider in BPC for NetWeaver. What is
supported? (2)
Question18: You are working in a B PC Standard system
For which of the following models do you have to create at least two "Drivers and Rates" type models?
Question19: Which of the following model-specific business rules requires the environment-specific business rules?
Question20: How do you configure the data Manager package to execute a specific logic script file?
Please choose the correct answer.
Response:
Question21: What value is used in the destination flow column of the currency conversion business rule when there is no
subtable type dimension in the Application? (1)
Question22: When validating the 'FXTrans.LGF' file, you get a validation error stating that the currency dimension is missing a property. What property is missing? 1
Question23: You are using BPC Standard. You want to calculate revenue as a product of the units sold and price per unit and save the results in the database. How can you achieve this?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question24: In Analysis for Office you have an input-ready query with accounts in the rows and all periods(month)of2019 as well as the totaal for 2019 in the columns. You have a value of '1200' for '100' for JAN to DEC.
You lock the cells for JAN AND FEB and enter'1500'for2019.When you recalculate the data,whathappens?
Note:There are 2 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question25: You are working in BPC Standard.Which of the following calculation options is HANA optimization?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question26: You want to enable users to resolve the "out of balance" issue when blocking controls fail. When you
configure the controls, what do you attach to the blocking controls? (1)
Question27: Which of the following taks can you perform using a Data Manager package deliverd by SAP?
There are 3 correct answers to this question.
Response:
Question28: What are the Out of the Box solution for loading the master data load? 2
Question29: A user tries to connect to a model using the excel interface of the EPM Add-in. However, the model is not available. What could be the issue?
Please choose the correct answer.
Response:
Question30: Where is archived audit data stored in BPC for the SAP NetWeaver technology platform? Please choose the
correct answer.
Question31: Which steps are mandatory if you want to implement the work status?
There are 3 correct answers to this question.
Response:
Question32: You are working with BPC Embedded in a replicated scenario. You need to create a Local Provider. Aside from the Native SAP HANA table, which other objects are system generated? Note: There are 2 correct answers to this question.
Question33: What can be used as a data source in Analysis for Office? Note: There are 3 correct answers to this question.
Question34: How do you configure the data Manager package to execute a specific logic script file? (1)
Question35: What is entered in the group account when you configure AR/AP intercompany eliminations and adjustment business rule?
Please choose the correct answer.
Response:
Question36: How to reset the consolidation status?
choose the correct answer
Response:
Question37: Which components does BPC Embedded Consolidation use in a Replicated Scenario? Note: There are 2 correct answers to this question.
Question38: You need to calculate ownership using these values:
Company D owns 70% of company A and 10% of company B.
Company A owns 50% of company B.
Using the Group share method, what percentage ownership does company D have of company B?
Question39: Find out the Environment models from the following (3)
Question40: Which data source types are processed by the balance Carry Forward rule?
Note:There are 2 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question41: You are formatting an EPM Report.Which of the following features are configured in the EPM formatting sheet? (2)
Question42: What is best business practice to execute multiple iterations of a budgeting process in BPC?
Please choose the correct answer.
Response:
Question43: What are the two modes of transport supported? (2)
Question44: Your customer wants to use a unique business rule to translate currency for selected entities. Which property
do you set for the selected entities to meet this requirement? (1)
Question45: You CANNOT view the final data in Real Time Consolidation.What could be the issue?
Note:There are 2 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question46: Which transaction allows you to access the system_constant.lgf and MDXIib.lgf files in SAP Business Object Business Planning and Consolidation version for NetWeaver? (1)
Question47: You EPM Report is enabled to send data and comments. You type in a revenue value and a comment in the
EPM report and save the data. Where is the data stored? (1)
Question48: You are working in BPC Standard. Which dimensions must be identical in all models that use the Exchange Rate Model?
Note:There are 2 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question49: Select the key term for-SAP business information warehouse
choose the correct answer
Response:
Question50: What needs to run before ownership elimination?
Please choose the correct answer.
Response:
Question51: You use the INC account type for revenue accounts and the EXP account type for expense accounts. What is
displayed in a planning and consolidation report when incomes are stored as negative values and expenses are
stored as a positive values (dimensions)? 2 BPC440
Question52: What does a consolidation model contains?
there are 2 correct answers to this question
Response:
Question53: When executing the ownership calculation you receive an error message. You therefore analyze the group/entity structure in the attached screenshot Which method type is missing in the consolidations method?
Question54: Which of the following values can you use in the destination flow to configure the currency translation business rule? (2)
Question55: When using US eliminations, which dimensions must you include in the model? (2)
Question56: What is the maximum length of a characteristic value in BPC Embedded?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question57: You are working in BPC Standard.
Which of the following dimension types are required for an ownership type model?
Note: There are 3 correct answers to this question
Question58: What is entered in the destination group account when setting the AR/AP intercompany elimination business
rule with the automatic adjustment business rules? 1 BPC440
Question59: You are using BPC Standard You want to calculate revenue as a product of the units sold and price per unit and save the results in the database How can you achieve this?
Question60: Which of the following dimension types are mandatory for the Financial model type? (3)
Question61: In SAP BusinessObjects Planning and Consolidation for NetWeaver, the language texts are missing. How do
you fix this issue? (1)
Question62: What interfaces can you use during the step Define Action when setting up a BPF?
Please choose the correct answer.
Response:
Question63: Identify the factors involved in Business Process Flow
there are 2 correct answers to this question
Response:
Question64: You are working in a BPC Embedded system.Which objects are needed to run a calculation based on custom HANA SQL?
Note:There are 2 correct answer to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question65: You are working in a BPC Standard system.For which of the following models do you have to create at least two"Drivers and Rates"type models?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question66: What fields are required to eliminate the investment when using the 'All Formula'? 2 BPC440
Question67: You are using BPC 11.0.
From which of the following objects can you import data using the "Load Transaction Data from BW infoProvider" data manager package?
Question68: You are working in a BPC Embedded system. You need to configure the task sequence for month-end closing. Which of the following settings must be configured?
Note: There are 2 correct answers to this question.
Response:
Question69: You are formatting an EPM Report.Which of the following features are configured in the EPM formatting sheet?
Note: There are 2 correct answers to the question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question70: Which EV expansion option is used to return the current member and its dependents?
Please choose the correct answer.
Response:
Question71: How to create a model?
Choose a correct answer
Response:
Question72: Which EV expansion option is used to return the current member and its dependents? Please choose the
correct answer.
Question73: You are working in BPC Embedded.Data audit is enabled for a local provide.Whatfileds are added to the local
provider database table? (3)
Question74: How can an Aggregation Level be used?
Note:There are 3 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question75: You are working in a BPC Optimized system and you are setting up data retraction. Which of the following SAP S/4HANA core tables does retraction book to?
Question76: You are configuring consolidation for BPC Standard.
Which dimensions must be the same for consolidation, rate, and ownership models?
Note: There are 2 correct answers to this question.
Question77: Which properties are required to carry out currency translation for legal consolidation? (2)
Question78: What is entered in the destination group account when replacing the US elimination business rule with the automatic adjustment business rule? (1)
Question79: The Account type dimension consists of three properties? What are they
there are 3 correct answers to this question
Response:
Question80: You are working in a BPC Optimized system.You need a planning function to copy actual data to plan data.Which of the following characteristics must be included in the fileds to change? (1)
Question81: What transaction code allows you to access the 'system_constants.lgf and 'MDXIib.lgf files in BPC for NetWeaver?
Question82: What transaction code allows you to access the 'system_constants.lgf and 'MDXIib.lgf files in BPC for
NetWeaver?
Question83: Which dimensions can you use to configure the Balance Carry Forward business rule?
Note: There are 3 correct answers to the question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question84: Where do you activate the parameter that is used to automatically refresh the input form when you open it (input forms and report)?
Please choose the correct answer.
Response:
Question85: How can characteristic relationships be used? Note: There are 3 correct answers to this question
Question86: In BPC NetWeaver, the language texts are missing. How do you fix this issue?
Please choose the correct answer.
Response:
Question87: Which implementation step is mandatory to set up an on-the-fly KPI calculation? (1)
Question88: Name the folder that the users has access to depend his/ her access account Choose the correct answer Response:
Question89: Which of the following is possible in the data loading process in BPC for NetWeaver?
Please choose the correct answer.
Response:
Question90: Which of the following rules are based on business rules (models)? 3
Question91: To add custom dimensions automatically to BPC Optimized structures,what do you use?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question92: Which user account do you need to log onto SAP BPC version for NetWeaver?
Question93: A customer wants to use special exchange rates for only 2 out of 160 entities when doing currency translation. What dimension and what property do you use for that? (1)
Question94: What is a restriction for BPC validation rules in BPC for NetWeaver?
Please choose the correct answer.
Response:
Question95: Data is loaded only in the 'F_OPE' flow/subtable. When executing the currency translation for the first time, the CTA_ACT in F_CTA is empty. What is the problem with the logic?
Response:
Question96: What rows are displayed in an EVDRE report for the MemberSet 'SELF.DEP*? (1)
Question97: Which application type is optional in BPC for consolidation of investments and currency translation?
Response:
Question98: You need to configure work status to help control the planning process while implementing BPC Standard. Which steps are required?
Note: There are 2 correct answers to this question.
Response:
Question99: You are developing the following script logic to perform an allocation . To which destination members is the
above script logic writing the record? (3) --> ver el script en el word, aqui no lo pilla
Question100: You have created controls and a user has teasted them for the current period.However,period in the Controls Monitor.How do you resolve this issue?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question101: Which EV functions can support the posting process of an Input Schedule?
(Choose two)
There are 2 correct answers to this question.
Response:
Question102: You are working in a BPC Embedded System.What Options do you have when maintaining members and properties of local dimensions?
Note:There are 2 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question103: In Analysis for Office you have an input-ready query with accounts in the rows and all periods(month)of2019
as
well as the totaal for 2019 in the columns. You have a value of '1200' for '100' for JAN to DEC.
You lock the cells for JAN AND FEB and enter'1500'for2019.When you recalculate the data,whathappens? (2)
Question104: You have developed an EPM input form and would like to ensure a validation of cells message box pops up after a user saves data.How can you accomplish this?
Note: There are 2 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question105: You use the DESTINATION_APP keyword in your script logic. If the source model contains fewer
dimensions that the target, which operator do you use to derive the missing dimensions? 1
Question106: After running consolidation you notice that the elimination offset account is wrong What property could have the incorrect value?
Question107: Where is archived audit data stored in BPC for the SAP NetWeaver technology platform? Please choose the correct answer.
Question108: What tasks are accomplished during full optimization in BPC for NetWeaver? (2)
Question109: You are working in a BPC Embedded system. Which objects are needed to run a calculation based on custom
HANA SQL? (2)
Question110: The Consolidation Monitor displays a blank screen for the current period although the previous period has been displayed properly. What is missing? (1)
Question111: You have defined the global definition in the business rules.which of the following ownership accounts must contain data if you want to perform the ownership calculation?
There are 2 correct answers to this question.
Response:
Question112: Which of the following conventions apply to dimension property Ids? (2)
Question113: A report has been created with products in the rows displayed in a hierarchy.You would like to display the product members and parents in different colors based on the relative position in the hierarchy.
Which of the following options in the EPM add-in will allow you to accomplish this?
Note:There are 2 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question114: The access rights you can assign to the sets of members are (3)
Question115: Business warehouse, Planning and consolidation Leads to.......?
Please choose correct answer
Response:
Question116: What steps are required to save new members from the member sheet to the database of the admin console?
There are 2 correct answers to this question.
Response:
Question117: 22. You are working in a BPC Embedded System.
What options do you have when maintaining members and properties of local dimensions?
Note: There are 2 correct answers to this question.
Question118: What can be used as a data source in Analysis for Office?
Note:There are 3 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question119: You are working in a BPC Standard SystemThe users are complanning about a message that the system is
offline.What might be the issue? (1)
Question120: Find out the options uses to optimize your model for improvement in system performance There are 2 correct answers to this question Response:
Question121: When you create a new model from an existing model,which items can be copied?
Note:There are 2 correct answers to this question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question122: What dimension property is required for consolidation of investments? 1 BPC440 O D.
Question123: You are using BPC Standard 11.0.Which of the following do you define in the US Elimination Business Rule?
Note: There are 3 correct answers to the question.
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question124: Which settings do you need to make for the Source Account to calculate the annual net income (ANI) for the liability account?
Please choose the correct answer.
Response:
Question125: Find out the options uses to optimize your model for improvement in system performance: (2)
Question126: u to identify system postings? 1 BPC440What value for the property in the datasource dimension allows yo
Question127: What are the steps required to configure controls? 3 BPC440
Question128: Which of the following dimensions is automatically selected when you create a business process flow template? Please choose the correct answer.
Question129: What are valid MDX expansion options?
There are 3 correct answers to this question.
Response:
Question130: You insert an input-enabled query as a data source in Analysis for Office. You update values and would like to work with data in the planning buffer without storing data persistently in the database.
Which standard Analysis for Office methods can you use accomplish this?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response:
Question131: How to reset the consolidation status? (1)
Question132: You are working in a BPC Embedded system. Which objects are needed to run a calculation based on custom HANA SQL? (2)
Question133: Which hierarchy is used in the consolidation monitor?
Please choose the correct answer.
Response:
Question134: Business warehouse, Planning and consolidation Leads to.......? (1)
Question135: What value is assigned to the ACCOUNT3 with the following Script Logic?
*WHEN ACCOUNT
*IS ACCOUNT1, ACCOUNT2
*REC (FACTOR=1, ACCOUNT=ACCOUNT3)
*ENDWHEN
*COMMIT
Please choose the correct answer.
Response:
Question136: Which rlimension type can you use for the context when you use the controls monitor in a financial model? There are 3 correct answers to this question.
Question137: You need to calculate ownership using these values.Company D owns 70% of company A and 10% of company B.Company A owns 50% of company B.
Using the group share method,what percentage ownership does company D have of company B?
Note: Answers to this question are not verified by our experts, please study yourself and select the appropriate answers.
Contribute: Please send the correct answers with reference text/link on [email protected] to get up to 50% cashback.
Response: